<?php
  // equipment type (every type of equipment exactly once)
  require_once dirname(__FILE__)."/../purin2/alter/alter.php";

  // drop or clear
  puSql("drop table eqty");
  puDelete("delete from eqty");

  // create table
  puSql("create table eqty (
    i_eqty integer auto_increment not null, -- serial
    j_eqlo integer not null,                -- location of equipment
    v_sprite varchar(50) character set utf8 collate utf8_general_ci not null,          -- sprite, in case of multiple race replace -RACE with -male or -female
    v_name varchar(50) character set utf8 collate utf8_general_ci not null,            -- name of the equipment
    i_red integer,                          -- red multiplier, 255 for 1, can be even more than 255 for bright colors, e.g. 400
    i_green integer,                        -- green multiplier
    i_blue integer,                         -- blue multiplier
    primary key (i_eqty)
  )");

  // index
  puSql("create unique index p_eqty_1 on eqty (i_eqty)");
  // puSql("create unique index s_eqty_1 on eqty (v_sprite)"); -- some sprites has the same sprite file but different color modifiers after |
?>